8737c525a846a492e6885e7aef7714cb98b0cd65,PlugIns/FrontBasePlugIn/Sources/com/webobjects/jdbcadaptor/FrontbasePlugIn.java,FrontbaseSynchronizationFactory,foreignKeyConstraintStatementsForRelationship,#EORelationship#,558

Before Change


						sql.append(", ");

					sql.append("\"");
					sql.append(((EOAttribute) attributes.objectAtIndex(i)).columnName().toUpperCase());
					sql.append("\"");
				}

After Change


				sql.append(quoteTableName(tableName.toUpperCase()));
				sql.append(" ADD");

				StringBuffer constraint = new StringBuffer(" CONSTRAINT FOREIGN_KEY_");
				constraint.append(tableName);
				
				StringBuffer fkSql = new StringBuffer(" FOREIGN KEY (");
				NSArray attributes = relationship.sourceAttributes();

				for (int i = 0; i < attributes.count(); i++) {
					constraint.append("_");
					if (i != 0) 
						fkSql.append(", ");

					fkSql.append("\"");
					String columnName = ((EOAttribute) attributes.objectAtIndex(i)).columnName();
					fkSql.append(columnName.toUpperCase());
					constraint.append(columnName);
					fkSql.append("\"");
				}